Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	265
Missing cells	368
Missing cells (%)	7.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	67.9 KiB
Average record size in memory	262.5 B

Variable types

NUM	16
CAT	2

Warnings

`SEM` is highly correlated with `MES` and 2 other fields	High correlation
`MES` is highly correlated with `SEM` and 2 other fields	High correlation
`COMP_ENV` is highly correlated with `CAR_PKL`	High correlation
`CAR_PKL` is highly correlated with `COMP_ENV` and 3 other fields	High correlation
`VENTA` is highly correlated with `CAR_PKL` and 2 other fields	High correlation
`COSTO` is highly correlated with `CAR_PKL` and 2 other fields	High correlation
`UTIL` is highly correlated with `CAR_PKL` and 2 other fields	High correlation
`MES_CFD` is highly correlated with `MES` and 2 other fields	High correlation
`SEM_CFD` is highly correlated with `MES` and 2 other fields	High correlation
`CAR_PAQ` has 3 (1.1%) missing values	Missing
`COMP_PAQ` has 181 (68.3%) missing values	Missing
`LACT_Q` has 184 (69.4%) missing values	Missing
`FECHA` has unique values	Unique
`F_CFD` has unique values	Unique
`BEB_REF` has 6 (2.3%) zeros	Zeros
`DESC` has 152 (57.4%) zeros	Zeros
`C_CFD` has 88 (33.2%) zeros	Zeros

Reproduction

Analysis started	2020-12-16 02:53:26.095423
Analysis finished	2020-12-16 02:55:45.428822
Duration	2 minutes and 19.33 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

MES
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.871698113
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	2.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	7
95-th percentile	9
Maximum	9
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.519347661
Coefficient of variation (CV)	0.5171395276
Kurtosis	-1.198292884
Mean	4.871698113
Median Absolute Deviation (MAD)	2
Skewness	0.01420693516
Sum	1291
Variance	6.347112636
Monotocity	Increasing

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
8	31	11.7%
7	31	11.7%
5	31	11.7%
3	31	11.7%
1	31	11.7%
6	30	11.3%
4	30	11.3%
2	29	10.9%
9	21	7.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	31	11.7%
2	29	10.9%
3	31	11.7%
4	30	11.3%
5	31	11.7%
6	30	11.3%
7	31	11.7%
8	31	11.7%
9	21	7.9%

Value	Count	Frequency (%)
9	21	7.9%
8	31	11.7%
7	31	11.7%
6	30	11.3%
5	31	11.7%
4	30	11.3%
3	31	11.7%
2	29	10.9%
1	31	11.7%

SEM
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	39
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	19.71320755
Minimum	1
Maximum	39
Zeros	0
Zeros (%)	0.0%
Memory size	2.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	10
median	20
Q3	29
95-th percentile	37
Maximum	39
Range	38
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	10.95275733
Coefficient of variation (CV)	0.5556050329
Kurtosis	-1.198329576
Mean	19.71320755
Median Absolute Deviation (MAD)	9
Skewness	-0.0005269962524
Sum	5224
Variance	119.9628931
Monotocity	Increasing

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
20	7	2.6%
38	7	2.6%
18	7	2.6%
17	7	2.6%
16	7	2.6%
15	7	2.6%
14	7	2.6%
13	7	2.6%
12	7	2.6%
11	7	2.6%
10	7	2.6%
9	7	2.6%
8	7	2.6%
7	7	2.6%
6	7	2.6%
5	7	2.6%
4	7	2.6%
19	7	2.6%
21	7	2.6%
2	7	2.6%
22	7	2.6%
37	7	2.6%
36	7	2.6%
35	7	2.6%
34	7	2.6%
Other values (14)	90	34.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	1.9%
2	7	2.6%
3	7	2.6%
4	7	2.6%
5	7	2.6%
6	7	2.6%
7	7	2.6%
8	7	2.6%
9	7	2.6%
10	7	2.6%

Value	Count	Frequency (%)
39	1	0.4%
38	7	2.6%
37	7	2.6%
36	7	2.6%
35	7	2.6%
34	7	2.6%
33	7	2.6%
32	7	2.6%
31	7	2.6%
30	7	2.6%

FECHA
Categorical

UNIQUE

Distinct	265
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	2.2 KiB

06/06/2020	1
21/09/2020	1
12/09/2020	1
10/05/2020	1
10/09/2020	1
Other values (260)	260

Common Values
Overview

Value	Count	Frequency (%)
06/06/2020	1	0.4%
21/09/2020	1	0.4%
12/09/2020	1	0.4%
10/05/2020	1	0.4%
10/09/2020	1	0.4%
17/02/2020	1	0.4%
30/04/2020	1	0.4%
02/06/2020	1	0.4%
25/08/2020	1	0.4%
16/03/2020	1	0.4%
18/05/2020	1	0.4%
05/02/2020	1	0.4%
02/02/2020	1	0.4%
28/04/2020	1	0.4%
15/03/2020	1	0.4%
02/04/2020	1	0.4%
29/03/2020	1	0.4%
18/01/2020	1	0.4%
11/01/2020	1	0.4%
25/07/2020	1	0.4%
28/01/2020	1	0.4%
05/09/2020	1	0.4%
22/02/2020	1	0.4%
06/02/2020	1	0.4%
07/07/2020	1	0.4%
Other values (240)	240	90.6%

Frequencies of value counts

Unique

Unique	265 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Overview of Unicode Properties

Unique unicode characters	11
Unique unicode categories	2 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	901	34.0%
2	667	25.2%
/	530	20.0%
1	153	5.8%
3	69	2.6%
5	57	2.2%
7	57	2.2%
8	57	2.2%
4	56	2.1%
6	56	2.1%
9	47	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2120	80.0%
Other Punctuation	530	20.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	901	42.5%
2	667	31.5%
1	153	7.2%
3	69	3.3%
5	57	2.7%
7	57	2.7%
8	57	2.7%
4	56	2.6%
6	56	2.6%
9	47	2.2%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	530	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2650	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	901	34.0%
2	667	25.2%
/	530	20.0%
1	153	5.8%
3	69	2.6%
5	57	2.2%
7	57	2.2%
8	57	2.2%
4	56	2.1%
6	56	2.1%
9	47	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2650	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	901	34.0%
2	667	25.2%
/	530	20.0%
1	153	5.8%
3	69	2.6%
5	57	2.2%
7	57	2.2%
8	57	2.2%
4	56	2.1%
6	56	2.1%
9	47	1.8%

BEB_REF
Real number (ℝ_≥0)

ZEROS

Distinct	34
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.288679245
Minimum	0
Maximum	35
Zeros	6
Zeros (%)	2.3%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
median	7
Q3	12
95-th percentile	23
Maximum	35
Range	35
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.093575315
Coefficient of variation (CV)	0.76367965
Kurtosis	1.211701267
Mean	9.288679245
Median Absolute Deviation (MAD)	3
Skewness	1.320725831
Sum	2461.5
Variance	50.31881075
Monotocity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
5	34	12.8%
4	27	10.2%
6	24	9.1%
7	20	7.5%
3	19	7.2%
8	14	5.3%
9	14	5.3%
11	11	4.2%
10	11	4.2%
2	10	3.8%
12	8	3.0%
21	7	2.6%
0	6	2.3%
16	6	2.3%
22	6	2.3%
1	5	1.9%
23	5	1.9%
15	5	1.9%
13	5	1.9%
19	4	1.5%
18	4	1.5%
20	3	1.1%
14	3	1.1%
27	2	0.8%
28	2	0.8%
Other values (9)	10	3.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	2.3%
1	5	1.9%
2	10	3.8%
3	19	7.2%
4	27	10.2%
5	34	12.8%
6	24	9.1%
7	20	7.5%
7.5	1	0.4%
8	14	5.3%

Value	Count	Frequency (%)
35	1	0.4%
32	1	0.4%
31	1	0.4%
30	2	0.8%
29	1	0.4%
28	2	0.8%
27	2	0.8%
26	1	0.4%
25	1	0.4%
23	5	1.9%

CAR_PAQ
Real number (ℝ_≥0)

MISSING

Distinct	47
Distinct (%)	17.9%
Missing	3
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	11.86641221
Minimum	0
Maximum	99
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	4
median	7
Q3	14
95-th percentile	36.9
Maximum	99
Range	99
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	13.24450648
Coefficient of variation (CV)	1.116134029
Kurtosis	9.32851611
Mean	11.86641221
Median Absolute Deviation (MAD)	4
Skewness	2.565280147
Sum	3109
Variance	175.4169518
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
4	23	8.7%
5	20	7.5%
1	20	7.5%
8	19	7.2%
2	19	7.2%
3	19	7.2%
7	15	5.7%
6	14	5.3%
10	12	4.5%
12	10	3.8%
11	9	3.4%
9	8	3.0%
18	5	1.9%
14	5	1.9%
15	5	1.9%
34	4	1.5%
16	4	1.5%
26	3	1.1%
43	3	1.1%
25	3	1.1%
19	3	1.1%
35	3	1.1%
21	3	1.1%
24	2	0.8%
32	2	0.8%
Other values (22)	29	10.9%
(Missing)	3	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
1	20	7.5%
2	19	7.2%
3	19	7.2%
4	23	8.7%
5	20	7.5%
6	14	5.3%
7	15	5.7%
8	19	7.2%
9	8	3.0%

Value	Count	Frequency (%)
99	1	0.4%
70	1	0.4%
64	1	0.4%
54	1	0.4%
53	2	0.8%
48	1	0.4%
45	1	0.4%
43	3	1.1%
42	1	0.4%
38	1	0.4%

CAR_PKL
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	263
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.80792917
Minimum	0
Maximum	150.47143
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	7.378816
Q1	14.3999
median	23.3879
Q3	41.81135
95-th percentile	80.430516
Maximum	150.47143
Range	150.47143
Interquartile range (IQR)	27.41145

Descriptive statistics

Standard deviation	24.41681981
Coefficient of variation (CV)	0.7676331169
Kurtosis	2.264236552
Mean	31.80792917
Median Absolute Deviation (MAD)	10.65933
Skewness	1.456451917
Sum	8429.10123
Variance	596.1810897
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2	0.8%
9.75	2	0.8%
7.55	1	0.4%
25.83813	1	0.4%
13.7622	1	0.4%
38.11	1	0.4%
21.77855	1	0.4%
37.765	1	0.4%
18.33491	1	0.4%
26.3	1	0.4%
5.07	1	0.4%
69.55	1	0.4%
47.83105	1	0.4%
90.71076	1	0.4%
41.75683	1	0.4%
74.27464	1	0.4%
32.19942	1	0.4%
65.51091	1	0.4%
15.88125	1	0.4%
17.08726	1	0.4%
10.185	1	0.4%
26.12762	1	0.4%
15.5441	1	0.4%
21.83	1	0.4%
27.04841	1	0.4%
Other values (238)	238	89.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
1.8	1	0.4%
2	1	0.4%
2.16279	1	0.4%
2.43	1	0.4%
2.93	1	0.4%
5.02682	1	0.4%
5.07	1	0.4%
6.80209	1	0.4%
7.12143	1	0.4%

Value	Count	Frequency (%)
150.47143	1	0.4%
108.52534	1	0.4%
107.85996	1	0.4%
105.015	1	0.4%
95.7853	1	0.4%
93.06689	1	0.4%
92.50044	1	0.4%
90.71076	1	0.4%
87.35798	1	0.4%
85.46238	1	0.4%

COMP_ENV
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	111
Distinct (%)	41.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.48018868
Minimum	0
Maximum	112
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	7.1
Q1	14
median	21
Q3	36.5
95-th percentile	69.8
Maximum	112
Range	112
Interquartile range (IQR)	22.5

Descriptive statistics

Standard deviation	20.75398907
Coefficient of variation (CV)	0.7287166987
Kurtosis	1.592213484
Mean	28.48018868
Median Absolute Deviation (MAD)	9
Skewness	1.355259784
Sum	7547.25
Variance	430.7280625
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	10	3.8%
20.5	8	3.0%
21.5	8	3.0%
14.5	7	2.6%
9	7	2.6%
13	6	2.3%
15	6	2.3%
20	6	2.3%
10.5	6	2.3%
17	5	1.9%
19	5	1.9%
10	5	1.9%
21	5	1.9%
22.5	4	1.5%
36.5	4	1.5%
18	4	1.5%
30.5	4	1.5%
17.5	4	1.5%
31.5	4	1.5%
27.5	4	1.5%
18.5	4	1.5%
51	3	1.1%
16.5	3	1.1%
15.5	3	1.1%
13.5	3	1.1%
Other values (86)	137	51.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
2.5	1	0.4%
3	1	0.4%
3.5	1	0.4%
4	1	0.4%
5	1	0.4%
5.5	2	0.8%
6	3	1.1%
6.5	1	0.4%
7	1	0.4%

Value	Count	Frequency (%)
112	1	0.4%
110.5	1	0.4%
91.5	1	0.4%
91	1	0.4%
80	1	0.4%
79.5	1	0.4%
78.5	1	0.4%
78	1	0.4%
77	1	0.4%
75.5	1	0.4%

COMP_PAQ
Real number (ℝ_≥0)

MISSING

Distinct	9
Distinct (%)	10.7%
Missing	181
Missing (%)	68.3%
Infinite	0
Infinite (%)	0.0%

Mean	3.238095238
Minimum	0
Maximum	17
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	4
95-th percentile	6
Maximum	17
Range	17
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.382764657
Coefficient of variation (CV)	0.7358537913
Kurtosis	12.23984628
Mean	3.238095238
Median Absolute Deviation (MAD)	1
Skewness	2.578440819
Sum	272
Variance	5.677567413
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2	32	12.1%
4	20	7.5%
6	12	4.5%
1	12	4.5%
8	2	0.8%
3	2	0.8%
0	2	0.8%
17	1	0.4%
5	1	0.4%
(Missing)	181	68.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
1	12	4.5%
2	32	12.1%
3	2	0.8%
4	20	7.5%
5	1	0.4%
6	12	4.5%
8	2	0.8%
17	1	0.4%

Value	Count	Frequency (%)
17	1	0.4%
8	2	0.8%
6	12	4.5%
5	1	0.4%
4	20	7.5%
3	2	0.8%
2	32	12.1%
1	12	4.5%
0	2	0.8%

LACT_Q
Real number (ℝ_≥0)

MISSING

Distinct	5
Distinct (%)	6.2%
Missing	184
Missing (%)	69.4%
Infinite	0
Infinite (%)	0.0%

Mean	1.345679012
Minimum	0
Maximum	4
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	4
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.6921071779
Coefficient of variation (CV)	0.5143181781
Kurtosis	2.613059332
Mean	1.345679012
Median Absolute Deviation (MAD)	0
Skewness	1.504362408
Sum	109
Variance	0.4790123457
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
1	56	21.1%
2	17	6.4%
3	5	1.9%
0	2	0.8%
4	1	0.4%
(Missing)	184	69.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
1	56	21.1%
2	17	6.4%
3	5	1.9%
4	1	0.4%

Value	Count	Frequency (%)
4	1	0.4%
3	5	1.9%
2	17	6.4%
1	56	21.1%
0	2	0.8%

TOR_TOR
Real number (ℝ_≥0)

Distinct	56
Distinct (%)	21.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.3309434
Minimum	0
Maximum	70
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2.2
Q1	7
median	11
Q3	23
95-th percentile	45.6
Maximum	70
Range	70
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	14.02628299
Coefficient of variation (CV)	0.8588776933
Kurtosis	1.609754164
Mean	16.3309434
Median Absolute Deviation (MAD)	6
Skewness	1.44140782
Sum	4327.7
Variance	196.7366146
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	23	8.7%
6	23	8.7%
9	18	6.8%
11	15	5.7%
12	14	5.3%
7	13	4.9%
4	11	4.2%
2	10	3.8%
3	9	3.4%
5	8	3.0%
14	8	3.0%
17	8	3.0%
10	5	1.9%
34	5	1.9%
13	5	1.9%
29	5	1.9%
18	5	1.9%
20	5	1.9%
23	4	1.5%
26	4	1.5%
15	4	1.5%
19	4	1.5%
28	4	1.5%
43	3	1.1%
38	3	1.1%
Other values (31)	49	18.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
1	2	0.8%
2	10	3.8%
3	9	3.4%
4	11	4.2%
5	8	3.0%
6	23	8.7%
7	13	4.9%
8	23	8.7%
9	18	6.8%

Value	Count	Frequency (%)
70	1	0.4%
66	1	0.4%
64	1	0.4%
60	1	0.4%
54	1	0.4%
53	1	0.4%
52	2	0.8%
51	2	0.8%
50	1	0.4%
49	1	0.4%

VENTA
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	264
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11979.41449
Minimum	0
Maximum	65869.64217
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2668.047062
Q1	5338.96422
median	8355.30021
Q3	15988.17494
95-th percentile	30474.96296
Maximum	65869.64217
Range	65869.64217
Interquartile range (IQR)	10649.21072

Descriptive statistics

Standard deviation	9868.453484
Coefficient of variation (CV)	0.8237842916
Kurtosis	5.8368932
Mean	11979.41449
Median Absolute Deviation (MAD)	3810.80084
Skewness	1.979130139
Sum	3174544.841
Variance	97386374.16
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2	0.8%
5837.6448	1	0.4%
2478.99862	1	0.4%
30638.32344	1	0.4%
4311.80188	1	0.4%
8003.04956	1	0.4%
4791.77854	1	0.4%
31952.78762	1	0.4%
11180.23118	1	0.4%
8609.395	1	0.4%
7805.55998	1	0.4%
17283.69027	1	0.4%
17145.22914	1	0.4%
4814.932	1	0.4%
12100.09628	1	0.4%
65869.64217	1	0.4%
25700.34	1	0.4%
6398.375	1	0.4%
21383.00639	1	0.4%
9705.2	1	0.4%
7631.685504	1	0.4%
15580.24122	1	0.4%
6588.39874	1	0.4%
13402.93052	1	0.4%
5356.31951	1	0.4%
Other values (239)	239	90.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
953.2	1	0.4%
1328.47	1	0.4%
1485.99991	1	0.4%
2024.69	1	0.4%
2400.92999	1	0.4%
2418.53	1	0.4%
2478.99862	1	0.4%
2500.75	1	0.4%
2521.25993	1	0.4%

Value	Count	Frequency (%)
65869.64217	1	0.4%
65186.365	1	0.4%
39419.36894	1	0.4%
37653.8714	1	0.4%
37149.36856	1	0.4%
35925.08891	1	0.4%
35904.09944	1	0.4%
35543.05746	1	0.4%
34049.29234	1	0.4%
33549.63659	1	0.4%

COSTO
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	264
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5977.859799
Minimum	0
Maximum	34543.85635
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1353.027384
Q1	2662.49746
median	3998.3555
Q3	7845.966177
95-th percentile	15573.27431
Maximum	34543.85635
Range	34543.85635
Interquartile range (IQR)	5183.468717

Descriptive statistics

Standard deviation	5014.677071
Coefficient of variation (CV)	0.8388749886
Kurtosis	6.381239694
Mean	5977.859799
Median Absolute Deviation (MAD)	1800.8645
Skewness	2.050190953
Sum	1584132.847
Variance	25146986.12
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2	0.8%
1432.0299	1	0.4%
6970.627398	1	0.4%
3949.131	1	0.4%
3729.00609	1	0.4%
3638.0742	1	0.4%
3845.25945	1	0.4%
3714.7289	1	0.4%
2702.142666	1	0.4%
6043.14649	1	0.4%
2221.776	1	0.4%
14879.18012	1	0.4%
4596.127368	1	0.4%
7362.0915	1	0.4%
8194.1005	1	0.4%
10194.41512	1	0.4%
3929.325774	1	0.4%
4793.0479	1	0.4%
17041.087	1	0.4%
7071.712962	1	0.4%
3889.597158	1	0.4%
5302.9364	1	0.4%
6724.60131	1	0.4%
4286.9402	1	0.4%
4338.12	1	0.4%
Other values (239)	239	90.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
499	1	0.4%
598.041	1	0.4%
872.15444	1	0.4%
910.8698	1	0.4%
1118.6334	1	0.4%
1263.252502	1	0.4%
1301.7246	1	0.4%
1310.438	1	0.4%
1318.4225	1	0.4%

Value	Count	Frequency (%)
34543.85635	1	0.4%
33142.7805	1	0.4%
18479.96385	1	0.4%
18442.60934	1	0.4%
18435.20009	1	0.4%
17588.79157	1	0.4%
17307.53838	1	0.4%
17217.59022	1	0.4%
17041.087	1	0.4%
16733.6167	1	0.4%

UTIL
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	264
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6009.031639
Minimum	0
Maximum	32065.5845
Zeros	2
Zeros (%)	0.8%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1262.86526
Q1	2561.10017
median	4228.165356
Q3	7509.720343
95-th percentile	16850.28883
Maximum	32065.5845
Range	32065.5845
Interquartile range (IQR)	4948.620173

Descriptive statistics

Standard deviation	5040.687346
Coefficient of variation (CV)	0.8388518565
Kurtosis	4.817947765
Mean	6009.031639
Median Absolute Deviation (MAD)	1970.315506
Skewness	1.914499273
Sum	1592393.384
Variance	25408528.92
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2	0.8%
10751.37485	1	0.4%
3048.152205	1	0.4%
16934.87102	1	0.4%
5925.81642	1	0.4%
6035.7595	1	0.4%
5987.86976	1	0.4%
8274.727128	1	0.4%
2139.674	1	0.4%
14547.95809	1	0.4%
4567.2318	1	0.4%
464.2	1	0.4%
1805.21217	1	0.4%
3022.24305	1	0.4%
21041.56885	1	0.4%
13130.45675	1	0.4%
3735.5327	1	0.4%
6510.8685	1	0.4%
613.84547	1	0.4%
2807.00392	1	0.4%
4485.0595	1	0.4%
7238.23458	1	0.4%
6975.44476	1	0.4%
3370.6132	1	0.4%
2516.24259	1	0.4%
Other values (239)	239	90.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.8%
464.2	1	0.4%
613.84547	1	0.4%
730.429	1	0.4%
801.626	1	0.4%
824.243	1	0.4%
1068.096	1	0.4%
1100.1075	1	0.4%
1113.8202	1	0.4%
1147.38008	1	0.4%

Value	Count	Frequency (%)
32065.5845	1	0.4%
31357.78582	1	0.4%
21041.56885	1	0.4%
19205.90755	1	0.4%
18856.69728	1	0.4%
18817.55922	1	0.4%
18708.49869	1	0.4%
18596.56106	1	0.4%
18350.85604	1	0.4%
17870.97862	1	0.4%

DESC
Real number (ℝ_≥0)

ZEROS

Distinct	72
Distinct (%)	27.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.476925075
Minimum	0
Maximum	110.700023
Zeros	152
Zeros (%)	57.4%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3.7
95-th percentile	42.652
Maximum	110.700023
Range	110.700023
Interquartile range (IQR)	3.7

Descriptive statistics

Standard deviation	16.530181
Coefficient of variation (CV)	2.210826086
Kurtosis	11.34099833
Mean	7.476925075
Median Absolute Deviation (MAD)	0
Skewness	3.140150361
Sum	1981.385145
Variance	273.2468838
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	152	57.4%
3.2	18	6.8%
1.9	9	3.4%
1.3	6	2.3%
3.7	6	2.3%
2.6	3	1.1%
3.8	2	0.8%
5.97	2	0.8%
12.9	2	0.8%
22.1	2	0.8%
2.5	2	0.8%
21.199	1	0.4%
18.1195	1	0.4%
110.700023	1	0.4%
5.2	1	0.4%
40.6615	1	0.4%
2.4	1	0.4%
29.388242	1	0.4%
26.2625	1	0.4%
7.5	1	0.4%
5.7	1	0.4%
45.9	1	0.4%
7.000056	1	0.4%
28.595	1	0.4%
3.5	1	0.4%
Other values (47)	47	17.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	152	57.4%
1.3	6	2.3%
1.9	9	3.4%
2.4	1	0.4%
2.5	2	0.8%
2.6	3	1.1%
2.7	1	0.4%
3.2	18	6.8%
3.5	1	0.4%
3.7	6	2.3%

Value	Count	Frequency (%)
110.700023	1	0.4%
93.6	1	0.4%
78.768	1	0.4%
75.589	1	0.4%
67.25	1	0.4%
65.4	1	0.4%
59.7	1	0.4%
52.62	1	0.4%
52.221	1	0.4%
52.2073	1	0.4%

MES_CFD
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.871698113
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	2.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	7
95-th percentile	9
Maximum	9
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.519347661
Coefficient of variation (CV)	0.5171395276
Kurtosis	-1.198292884
Mean	4.871698113
Median Absolute Deviation (MAD)	2
Skewness	0.01420693516
Sum	1291
Variance	6.347112636
Monotocity	Increasing

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
8	31	11.7%
7	31	11.7%
5	31	11.7%
3	31	11.7%
1	31	11.7%
6	30	11.3%
4	30	11.3%
2	29	10.9%
9	21	7.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	31	11.7%
2	29	10.9%
3	31	11.7%
4	30	11.3%
5	31	11.7%
6	30	11.3%
7	31	11.7%
8	31	11.7%
9	21	7.9%

Value	Count	Frequency (%)
9	21	7.9%
8	31	11.7%
7	31	11.7%
6	30	11.3%
5	31	11.7%
4	30	11.3%
3	31	11.7%
2	29	10.9%
1	31	11.7%

SEM_CFD
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	39
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	19.71320755
Minimum	1
Maximum	39
Zeros	0
Zeros (%)	0.0%
Memory size	2.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	10
median	20
Q3	29
95-th percentile	37
Maximum	39
Range	38
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	10.95275733
Coefficient of variation (CV)	0.5556050329
Kurtosis	-1.198329576
Mean	19.71320755
Median Absolute Deviation (MAD)	9
Skewness	-0.0005269962524
Sum	5224
Variance	119.9628931
Monotocity	Increasing

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
20	7	2.6%
38	7	2.6%
18	7	2.6%
17	7	2.6%
16	7	2.6%
15	7	2.6%
14	7	2.6%
13	7	2.6%
12	7	2.6%
11	7	2.6%
10	7	2.6%
9	7	2.6%
8	7	2.6%
7	7	2.6%
6	7	2.6%
5	7	2.6%
4	7	2.6%
19	7	2.6%
21	7	2.6%
2	7	2.6%
22	7	2.6%
37	7	2.6%
36	7	2.6%
35	7	2.6%
34	7	2.6%
Other values (14)	90	34.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	1.9%
2	7	2.6%
3	7	2.6%
4	7	2.6%
5	7	2.6%
6	7	2.6%
7	7	2.6%
8	7	2.6%
9	7	2.6%
10	7	2.6%

Value	Count	Frequency (%)
39	1	0.4%
38	7	2.6%
37	7	2.6%
36	7	2.6%
35	7	2.6%
34	7	2.6%
33	7	2.6%
32	7	2.6%
31	7	2.6%
30	7	2.6%

F_CFD
Categorical

UNIQUE

Distinct	265
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	2.2 KiB

06/06/2020	1
21/09/2020	1
12/09/2020	1
10/05/2020	1
10/09/2020	1
Other values (260)	260

Common Values
Overview

Value	Count	Frequency (%)
06/06/2020	1	0.4%
21/09/2020	1	0.4%
12/09/2020	1	0.4%
10/05/2020	1	0.4%
10/09/2020	1	0.4%
17/02/2020	1	0.4%
30/04/2020	1	0.4%
02/06/2020	1	0.4%
25/08/2020	1	0.4%
16/03/2020	1	0.4%
18/05/2020	1	0.4%
05/02/2020	1	0.4%
02/02/2020	1	0.4%
28/04/2020	1	0.4%
15/03/2020	1	0.4%
02/04/2020	1	0.4%
29/03/2020	1	0.4%
18/01/2020	1	0.4%
11/01/2020	1	0.4%
25/07/2020	1	0.4%
28/01/2020	1	0.4%
05/09/2020	1	0.4%
22/02/2020	1	0.4%
06/02/2020	1	0.4%
07/07/2020	1	0.4%
Other values (240)	240	90.6%

Frequencies of value counts

Unique

Unique	265 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Overview of Unicode Properties

Unique unicode characters	11
Unique unicode categories	2 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	901	34.0%
2	667	25.2%
/	530	20.0%
1	153	5.8%
3	69	2.6%
5	57	2.2%
7	57	2.2%
8	57	2.2%
4	56	2.1%
6	56	2.1%
9	47	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2120	80.0%
Other Punctuation	530	20.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	901	42.5%
2	667	31.5%
1	153	7.2%
3	69	3.3%
5	57	2.7%
7	57	2.7%
8	57	2.7%
4	56	2.6%
6	56	2.6%
9	47	2.2%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	530	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2650	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	901	34.0%
2	667	25.2%
/	530	20.0%
1	153	5.8%
3	69	2.6%
5	57	2.2%
7	57	2.2%
8	57	2.2%
4	56	2.1%
6	56	2.1%
9	47	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2650	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	901	34.0%
2	667	25.2%
/	530	20.0%
1	153	5.8%
3	69	2.6%
5	57	2.2%
7	57	2.2%
8	57	2.2%
4	56	2.1%
6	56	2.1%
9	47	1.8%

C_CFD
Real number (ℝ_≥0)

ZEROS

Distinct	119
Distinct (%)	44.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	58.63396226
Minimum	0
Maximum	325
Zeros	88
Zeros (%)	33.2%
Memory size	2.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	24
Q3	101
95-th percentile	214.2
Maximum	325
Range	325
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	71.08812005
Coefficient of variation (CV)	1.212405188
Kurtosis	0.7071538764
Mean	58.63396226
Median Absolute Deviation (MAD)	24
Skewness	1.173414062
Sum	15538
Variance	5053.520812
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	88	33.2%
1	12	4.5%
3	7	2.6%
2	5	1.9%
111	4	1.5%
21	3	1.1%
77	3	1.1%
88	3	1.1%
89	3	1.1%
67	3	1.1%
47	3	1.1%
127	2	0.8%
105	2	0.8%
56	2	0.8%
123	2	0.8%
62	2	0.8%
65	2	0.8%
66	2	0.8%
106	2	0.8%
104	2	0.8%
140	2	0.8%
6	2	0.8%
68	2	0.8%
97	2	0.8%
95	2	0.8%
Other values (94)	103	38.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	88	33.2%
1	12	4.5%
2	5	1.9%
3	7	2.6%
4	1	0.4%
5	1	0.4%
6	2	0.8%
7	1	0.4%
8	1	0.4%
9	1	0.4%

Value	Count	Frequency (%)
325	1	0.4%
292	1	0.4%
250	1	0.4%
246	2	0.8%
238	1	0.4%
231	1	0.4%
228	1	0.4%
224	1	0.4%
222	1	0.4%
221	1	0.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	MES	SEM	FECHA	BEB_REF	CAR_PAQ	CAR_PKL	COMP_ENV	COMP_PAQ	LACT_Q	TOR_TOR	VENTA	COSTO	UTIL	DESC	MES_CFD	SEM_CFD	F_CFD
0	1	1	01/01/2020	0.0	0.0	0.00000	0.0	0.0	0.0	0.0	0.00000	0.000000	0.000000	0.000	1	1	01/01/2020
1	1	1	02/01/2020	8.0	16.0	19.60570	17.0	2.0	1.0	8.0	9635.64470	4877.056060	4768.588640	0.000	1	1	02/01/2020
2	1	1	03/01/2020	5.0	9.0	7.55000	7.5	NaN	NaN	5.0	4361.45000	2221.776000	2139.674000	0.000	1	1	03/01/2020
3	1	1	04/01/2020	12.0	8.0	35.99762	31.0	NaN	1.0	20.0	11180.23118	5302.936400	5877.294780	0.000	1	1	04/01/2020
4	1	1	05/01/2020	16.0	17.0	53.04634	49.0	NaN	3.0	44.0	19168.84426	9682.981650	9485.862610	28.595	1	1	05/01/2020
5	1	2	06/01/2020	4.0	6.0	9.25500	28.5	NaN	NaN	14.0	5184.39500	2711.237275	2473.157725	0.000	1	2	06/01/2020
6	1	2	07/01/2020	3.0	1.0	10.25409	10.0	NaN	1.0	4.0	2776.88631	1379.147558	1397.738752	0.000	1	2	07/01/2020
7	1	2	08/01/2020	2.0	8.0	19.00682	15.0	NaN	NaN	9.0	7805.55998	3714.728900	4090.831080	3.870	1	2	08/01/2020
8	1	2	09/01/2020	6.0	10.0	12.99341	17.5	4.0	NaN	9.0	6082.47499	3036.443375	3068.031615	0.000	1	2	09/01/2020
9	1	2	10/01/2020	4.0	2.0	14.62201	15.0	2.0	NaN	8.0	4425.48949	2179.439640	2257.849850	0.000	1	2	10/01/2020

Last rows

	MES	SEM	FECHA	BEB_REF	CAR_PAQ	CAR_PKL	COMP_ENV	COMP_PAQ	LACT_Q	TOR_TOR	VENTA	COSTO	UTIL	DESC	MES_CFD	SEM_CFD	F_CFD	C_CFD
255	9	37	12/09/2020	11.0	12.0	61.76325	37.0	NaN	NaN	22.0	18945.47535	8194.100500	10751.374850	0.000	9	37	12/09/2020	47
256	9	37	13/09/2020	22.0	29.0	78.45698	78.5	2.0	2.0	38.0	31952.78762	15027.916600	16934.871020	43.040	9	37	13/09/2020	47
257	9	38	14/09/2020	3.0	7.0	16.62500	8.5	NaN	NaN	5.0	5971.87500	2922.114000	3049.761000	0.000	9	38	14/09/2020	104
258	9	38	15/09/2020	4.0	3.0	24.07459	21.0	NaN	NaN	12.0	7154.61471	3470.702050	3683.912660	0.000	9	38	15/09/2020	65
259	9	38	16/09/2020	1.0	21.0	40.68531	28.0	2.0	NaN	20.0	17131.68559	7924.484335	9217.201255	0.000	9	38	16/09/2020	69
260	9	38	17/09/2020	0.0	NaN	1.80000	10.0	NaN	NaN	4.0	953.20000	499.000000	464.200000	0.000	9	38	17/09/2020	87
261	9	38	18/09/2020	0.0	4.0	12.00251	12.5	NaN	NaN	15.0	4618.49949	2265.051200	2353.448290	0.000	9	38	18/09/2020	77
262	9	38	19/09/2020	2.0	5.0	7.12143	36.5	NaN	3.0	30.0	4544.49937	2932.861320	1621.638050	0.000	9	38	19/09/2020	56
263	9	38	20/09/2020	4.0	2.0	15.12000	44.5	NaN	2.0	26.0	5894.99500	3289.039500	2605.955500	17.485	9	38	20/09/2020	20
264	9	39	21/09/2020	0.0	2.0	7.51068	12.5	NaN	NaN	2.0	2478.99862	1430.160962	1148.837658	0.000	9	39	21/09/2020	54

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows